---
title: Google BigQuery
description: GoogleBigQueryTools enables agents to interact with Google BigQuery for large-scale data analysis and SQL queries.
---

## Example

The following agent can query and analyze BigQuery datasets:

```python
from agno.agent import Agent
from agno.tools.google_bigquery import GoogleBigQueryTools

agent = Agent(
    instructions=[
        "You are a data analyst assistant that helps with BigQuery operations",
        "Execute SQL queries to analyze large datasets",
        "Provide insights and summaries of query results",
        "Help with data exploration and table analysis",
    ],
    tools=[GoogleBigQueryTools(dataset="your_dataset_name")],
)

agent.print_response("List all tables in the dataset and describe the sales table", stream=True)
```

## Toolkit Params

| Parameter           | Type                | Default | Description                                                    |
| ------------------- | ------------------- | ------- | -------------------------------------------------------------- |
| `dataset`           | `str`               | `None`  | BigQuery dataset name (required).                            |
| `project`           | `Optional[str]`     | `None`  | Google Cloud project ID. Uses GOOGLE_CLOUD_PROJECT.         |
| `location`          | `Optional[str]`     | `None`  | BigQuery location. Uses GOOGLE_CLOUD_LOCATION.              |
| `credentials`       | `Optional[Any]`     | `None`  | Google Cloud credentials object.                             |
| `enable_list_tables`| `bool`              | `True`  | Enable table listing functionality.                         |
| `enable_describe_table` | `bool`          | `True`  | Enable table description functionality.                     |
| `enable_run_sql_query` | `bool`           | `True`  | Enable SQL query execution functionality.                   |

## Toolkit Functions

| Function         | Description                                                      |
| ---------------- | ---------------------------------------------------------------- |
| `list_tables`    | List all tables in the specified BigQuery dataset.              |
| `describe_table` | Get detailed schema information about a specific table.         |
| `run_sql_query`  | Execute SQL queries on BigQuery datasets.                       |



## Developer Resources

- View [Tools Source](https://github.com/agno-agi/agno/blob/main/libs/agno/agno/tools/google_bigquery.py)
- [BigQuery Documentation](https://cloud.google.com/bigquery/docs)
- [BigQuery SQL Reference](https://cloud.google.com/bigquery/docs/reference/standard-sql/)
